Company Name : 3i Infotech

1. Materialized view
2. What is bulk collect
3. Difference between leftouter join and right outer join
4. Uses of packages
5. How to execute a procedure
6. Sql load and write its program
7. Write a prigram to repy the result as production 20, sales 40 by using two table

Write a program using joins

8. Difference between local variable and bind variable
9. Tell me about youself
10. Rate u in sql and plsql

3i Infotech 1st Round Interview Questions :
*******

1) Tell about yourself
2) Tell about your project
3) Logics you implementaed in your project
4) Roles & Responsibilities in Support
5) Roles and responsibilities in development
6) Cursor Attributes
7) Trigger & Purpose of trigger
8) Write a query to track the trigger for scenario

Scenario : We have a table named employees having columns emp id, emp name, address, age , date of joining.
If customer entered string in age column instead of number... How will u track in trigger??

3i infotech interview questions:-

1.tell me about yourself
2.what is bulk collect.
3.what is cursor.
4.difference between trigger and constraint.
5.write procedure using pragma autonomous transaction.
6.how will you handle error.
7.tell about performance tuning.
8.if there is multiple error what is the range for raising error.
9.what is collect and attributes.
10.cursor and refcursor difference.